﻿CREATE TABLE [dbo].[CLM_837I_2410_DrugIdentification]
(
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[ItemIdentification_LIN03_ProductOrServiceId] [nvarchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PricingInfo_CTP03_DrugUnitPrice] [nvarchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PricingInfo_CTP04_NationalDrugUnitCount] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PricingInfo_CTP0501_UnitOrBasisForMeasurementCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrescriptionNumber_REF02_PrescriptionNumber] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL01_SubscriberHierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_HL01_PatientHierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSMessageId] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeId] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


